OpenEdge Data Management:<br />DataServer for ORACLE Creating a schema image

Once you have started ORACLE, started the DataServer processes, and created and connected to a local empty OpenEdge database, you can create the schema image. For information on starting ORACLE see the "Running ORACLE" section. For information on starting the DataServer processes, see the "Starting the DataServer processes" section.

From the Windows Data Administration main menu or the character-based Data Dictionary main window, select DataServer

ORACLE Utilities

Create DataServer Schema. The following dialog box appears:

Type a logical database name in the Logical Database Name field. You use the logical database name to connect to your ORACLE database. You also use it to refer to the database in your programming applications. For more information on database names, see OpenEdge Development: Progress 4GL Handbook .

If you are building a schema holder for a distributed ORACLE database, the logical name that you choose must be unique across the distributed database.

Note: If you place the schema image from a second non-OpenEdge database into a schema holder, you must give the second schema image a different logical database name from the first schema. The schema holder has one physical name, but each schema image it contains must have a different logical name.

In the Code Page field, type the name of the code page for the schema image. The name must be the OpenEdge name for the code page.

If your ORACLE environment uses a code page that OpenEdge does not support, you must supply a conversion table that translates between the OpenEdge client code page and the code page that ORACLE uses.

See the "Code pages" section in Chapter 2, "Initial Programming Considerations," for more information on how the DataServer handles code pages and code-page conversion tables. For a complete discussion of code pages, see OpenEdge Development: Internationalizing Applications .

In the Collation field, type the name of the collation table.

In the Oracle Version field, type the version number of ORACLE you are using. Possible values are 8 (the default), 9, or 10g.

Type the required connection parameters in the Connection Parameters field.

At a minimum, you need the User ID and Password parameters. Remote connections also require networking parameters. See the "Connecting a schema holder at startup" section in Chapter 6, "Connecting the DataServer," for a description of the required and optional connection parameters. This is how you identify the ORACLE user in an ORACLE Networking connection:


-U `userid`@`service-name` `-P` `password`

Choose OK. The utility prompts you to verify the ORACLE user ID and password.

If you did not specify the User ID (-U) and Password (-P) parameters in the previous dialog box, type an ORACLE user ID and password combination that has the privileges required for creating a schema holder.

Choose OK. The following dialog box appears:

Preselect the objects that the schema holder should contain. You can select these objects by object name, object type, or owner. By default, the wild card symbol (*) appears and specifies that the utility selects all objects. Typically, you should not include system-owned objects.

Choose OK.

If your ORACLE database is part of a distributed database, a dialog box listing the linked databases that make up the distributed database appears.

Select the linked databases whose objects you want to include in the schema holder, then choose OK. The Pre-Selection dialog box appears so that you can select objects by name, type, and owner.

Choose OK. The following dialog box appears:

Select the objects that you want to include in the schema holder.

If object names repeat across a distributed database, the DataServer qualifies each name by adding -n. For example, if your database has two INVOICE tables, the schema image will list them as INVOICE and INVOICE-1.

Choose OK. The DataServer reads information about the database objects and loads the data definitions into the schema holder. The time this process takes depends on the size and number of the ORACLE objects.

For each table, the DataServer selects an index or the native ROWID to support the Progress 4GL ROWID. If an ORACLE object (such as some views) does not support the ROWID function, the DataServer issues the warning, “Please check warnings and messages in the file ds_upd.e.” The ds_upd.e file lists the objects that do not support ROWID.

You can change the DataServer’s selection by using the OpenEdge Data Dictionary. For example, you can choose to use an alternate integer index or the native ROWID. See the "Defining the ROWID" section for instructions and the "ROWID function" section for more information on ROWID.

If the DataServer encounters ORACLE errors while creating or maintaining schema information or loading data, it displays the ORACLE message and message number on screen. See your ORACLE documentation for complete descriptions of the error messages.

The DataServer makes an additional connection to the schema holder when it creates, updates, or verifies a schema image. If you are connecting to multiple databases or schema images, make sure that you set the Number of Databases (-h) parameter to a value that accommodates the number of databases and schema images plus one.